SQL Query and Select TOP
Grid Designer provides the user with the options 'Query' and 'Select TOP' to be used when needed. Next, we will detail the benefits of these options in the report for the user.
SQL Query
For users with advanced SQL skills, the 'Query' option is available. It reveals the SQL statement that the dR View is going to execute against the data source. Please note that this feature is only applicable to SQL connections.
View the Query
To view the query, open the Grid Designer and create a new report or open an existing one. Then, click on the "Query" icon.
Select TOP
The option 'Select TOP' applies when it is not necessary to visualize all the data in Grid Designer. Keep in mind that using 'Select TOP 0' can retrieve all available data. Always check your selection to avoid unnecessary data retrieval.
Apply the Select TOP
To apply the "Select TOP" option, open the Grid Designer and create a new report or open an existing one. Then, click on the "Home" tab and select the "Select TOP" icon.